Configuring SQL Query Data Source Properties

The SQL Query data source uses a Structured Query Language (SQL) statement to query information using a Microsoft® Open Database Connectivity (ODBC) Data Source.

Data Package

The data package is matched to the SQL Query Wizard/Test through the following:

• ODBC Data Source Name
• Hashed SQL Query

Sample Data Packet file name:

DataPackage.SQLQuery_<ODBC_DSN>_<hashed_SQL Query>.Xml

Properties

DSN. Enter the 32-Bit ODBC Data Source Name to use for the SQL Query.

Impersonate. Enter option 1 to use impersonation instead of a SQL login. Default is to use the SQL Login user and password entered in the Collector connection settings tab.

ConnectionTmeout. The database connection time out in seconds.

CommandTmeout. The SQL Query execution time out in seconds.

Query1..n. The SQL Query to execute. Multiple SQL Queries can be collected by creating multiple Query(n) property entries.